/*
MariaDB Backup
Database: melon
Backup Time: 2023-12-07 15:57:47
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `dt_area`;
DROP TABLE IF EXISTS `dt_model`;
DROP TABLE IF EXISTS `dt_prop`;
DROP TABLE IF EXISTS `sys_config`;
DROP TABLE IF EXISTS `sys_dept`;
DROP TABLE IF EXISTS `sys_dict_data`;
DROP TABLE IF EXISTS `sys_dict_type`;
DROP TABLE IF EXISTS `sys_logininfor`;
DROP TABLE IF EXISTS `sys_menu`;
DROP TABLE IF EXISTS `sys_notice`;
DROP TABLE IF EXISTS `sys_oper_log`;
DROP TABLE IF EXISTS `sys_post`;
DROP TABLE IF EXISTS `sys_role`;
DROP TABLE IF EXISTS `sys_role_dept`;
DROP TABLE IF EXISTS `sys_role_menu`;
DROP TABLE IF EXISTS `sys_user`;
DROP TABLE IF EXISTS `sys_user_post`;
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `dt_area` (
  `uid` varchar(32) NOT NULL COMMENT '主键ID',
  `parent_id` varchar(32) DEFAULT NULL COMMENT '父级ID',
  `ancestors` varchar(300) DEFAULT NULL COMMENT '祖级列表',
  `code` varchar(20) NOT NULL COMMENT '编码',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `vip_level` int(11) DEFAULT NULL COMMENT 'VIP级别',
  `create_by` varchar(32) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `tenant_id` varchar(32) DEFAULT NULL COMMENT '分公司ID',
  `remark` varchar(900) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='资产主题';
CREATE TABLE `dt_model` (
  `uid` varchar(32) NOT NULL COMMENT '主键ID',
  `code` varchar(20) NOT NULL COMMENT '编码',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `data_type` varchar(2) NOT NULL COMMENT '类型;数据字典sys_def_type',
  `area_code` varchar(20) NOT NULL COMMENT '主题编码',
  `slave_sw` varchar(2) DEFAULT NULL COMMENT '扩展标记',
  `classify_sw` varchar(2) DEFAULT NULL COMMENT '支持分类',
  `class_prop_sw` varchar(2) DEFAULT NULL COMMENT '属性模板',
  `link_code` varchar(20) DEFAULT NULL COMMENT '引用编码;主分类，主模型',
  `audit_flag` varchar(2) DEFAULT '0' COMMENT '审核标记',
  `reject_flag` varchar(2) DEFAULT '0' COMMENT '回退标记',
  `state_json` varchar(2000) DEFAULT NULL COMMENT '状态JSON',
  `menu_json` varchar(2000) DEFAULT NULL COMMENT '环节JSON',
  `swt_json` varchar(2000) DEFAULT NULL COMMENT '开关JSON',
  `ext_json` varchar(2000) DEFAULT NULL COMMENT '扩展JSON',
  `version` int(11) DEFAULT NULL COMMENT '版本号',
  `vip_level` int(11) DEFAULT NULL COMMENT 'VIP级别',
  `create_by` varchar(32) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `tenant_id` varchar(32) DEFAULT NULL COMMENT '分公司ID',
  `remark` varchar(900) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='数据模型';
CREATE TABLE `dt_prop` (
  `uid` varchar(32) NOT NULL COMMENT '主键ID',
  `model_code` varchar(20) NOT NULL COMMENT '模型编码',
  `code` varchar(20) NOT NULL COMMENT '编码',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `data_type` varchar(2) NOT NULL COMMENT '数据类型;数据字典prop_data_type',
  `view_type` varchar(2) NOT NULL COMMENT '展示类型;数据字典prop_view_type',
  `src_type` varchar(2) NOT NULL COMMENT '来源类型;数据字典prop_source_type',
  `quick_sw` varchar(2) DEFAULT '0' COMMENT '快捷搜索',
  `advance_sw` varchar(2) DEFAULT '0' COMMENT '高级搜索',
  `view_sw` varchar(2) DEFAULT '0' COMMENT '列表显示',
  `link_code` varchar(20) DEFAULT NULL COMMENT '引用编码;数据来源模型',
  `hide_code` varchar(10) DEFAULT NULL COMMENT '隐藏编码',
  `col_code` varchar(10) DEFAULT NULL COMMENT '真实字段;数据库字段，查询使用',
  `col_num` int(11) DEFAULT 50 COMMENT '显示排序',
  `swt_json` varchar(2000) DEFAULT NULL COMMENT '开关JSON',
  `ext_json` varchar(2000) DEFAULT NULL COMMENT '扩展JSON',
  `edit_flag` varchar(2) DEFAULT '0' COMMENT '修改标记;0新增1变更2内置4停用',
  `vip_level` int(11) DEFAULT NULL COMMENT 'VIP级别',
  `create_by` varchar(32) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `tenant_id` varchar(32) DEFAULT NULL COMMENT '分公司ID',
  `remark` varchar(900) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='数据属性';
CREATE TABLE `sys_config` (
  `config_id` int(5) NOT NULL AUTO_INCREMENT COMMENT '参数主键',
  `config_name` varchar(100) DEFAULT '' COMMENT '参数名称',
  `config_key` varchar(100) DEFAULT '' COMMENT '参数键名',
  `config_value` varchar(500) DEFAULT '' COMMENT '参数键值',
  `config_type` char(1) DEFAULT 'N' COMMENT '系统内置（Y是 N否）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`config_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='参数配置表';
CREATE TABLE `sys_dept` (
  `dept_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '部门id',
  `parent_id` bigint(20) DEFAULT 0 COMMENT '父部门id',
  `ancestors` varchar(50) DEFAULT '' COMMENT '祖级列表',
  `dept_name` varchar(30) DEFAULT '' COMMENT '部门名称',
  `order_num` int(4) DEFAULT 0 COMMENT '显示顺序',
  `leader` varchar(20) DEFAULT NULL COMMENT '负责人',
  `phone` varchar(11) DEFAULT NULL COMMENT '联系电话',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `status` char(1) DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`dept_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='部门表';
CREATE TABLE `sys_dict_data` (
  `dict_code` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典编码',
  `dict_sort` int(4) DEFAULT 0 COMMENT '字典排序',
  `dict_label` varchar(100) DEFAULT '' COMMENT '字典标签',
  `dict_value` varchar(100) DEFAULT '' COMMENT '字典键值',
  `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
  `css_class` varchar(100) DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
  `list_class` varchar(100) DEFAULT NULL COMMENT '表格回显样式',
  `is_default` char(1) DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='字典数据表';
CREATE TABLE `sys_dict_type` (
  `dict_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典主键',
  `dict_name` varchar(100) DEFAULT '' COMMENT '字典名称',
  `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_id`) USING BTREE,
  UNIQUE KEY `dict_type` (`dict_type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='字典类型表';
CREATE TABLE `sys_logininfor` (
  `info_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '访问ID',
  `user_name` varchar(50) DEFAULT '' COMMENT '用户账号',
  `ipaddr` varchar(128) DEFAULT '' COMMENT '登录IP地址',
  `login_location` varchar(255) DEFAULT '' COMMENT '登录地点',
  `browser` varchar(50) DEFAULT '' COMMENT '浏览器类型',
  `os` varchar(50) DEFAULT '' COMMENT '操作系统',
  `status` char(1) DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
  `msg` varchar(255) DEFAULT '' COMMENT '提示消息',
  `login_time` datetime DEFAULT NULL COMMENT '访问时间',
  PRIMARY KEY (`info_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='系统访问记录';
CREATE TABLE `sys_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `menu_name` varchar(50) NOT NULL COMMENT '菜单名称',
  `parent_id` bigint(20) DEFAULT 0 COMMENT '父菜单ID',
  `order_num` int(4) DEFAULT 0 COMMENT '显示顺序',
  `path` varchar(200) DEFAULT '' COMMENT '路由地址',
  `component` varchar(255) DEFAULT NULL COMMENT '组件路径',
  `query` varchar(255) DEFAULT NULL COMMENT '路由参数',
  `is_frame` int(1) DEFAULT 1 COMMENT '是否为外链（0是 1否）',
  `is_cache` int(1) DEFAULT 0 COMMENT '是否缓存（0缓存 1不缓存）',
  `menu_type` char(1) DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
  `visible` char(1) DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
  `status` char(1) DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',
  `perms` varchar(100) DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(100) DEFAULT '#' COMMENT '菜单图标',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2010 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='菜单权限表';
CREATE TABLE `sys_notice` (
  `notice_id` int(4) NOT NULL AUTO_INCREMENT COMMENT '公告ID',
  `notice_title` varchar(50) NOT NULL COMMENT '公告标题',
  `notice_type` char(1) NOT NULL COMMENT '公告类型（1通知 2公告）',
  `notice_content` longblob DEFAULT NULL COMMENT '公告内容',
  `status` char(1) DEFAULT '0' COMMENT '公告状态（0正常 1关闭）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`notice_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='通知公告表';
CREATE TABLE `sys_oper_log` (
  `oper_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志主键',
  `title` varchar(50) DEFAULT '' COMMENT '模块标题',
  `business_type` int(2) DEFAULT 0 COMMENT '业务类型（0其它 1新增 2修改 3删除）',
  `method` varchar(100) DEFAULT '' COMMENT '方法名称',
  `request_method` varchar(10) DEFAULT '' COMMENT '请求方式',
  `operator_type` int(1) DEFAULT 0 COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
  `oper_name` varchar(50) DEFAULT '' COMMENT '操作人员',
  `dept_name` varchar(50) DEFAULT '' COMMENT '部门名称',
  `oper_url` varchar(255) DEFAULT '' COMMENT '请求URL',
  `oper_ip` varchar(128) DEFAULT '' COMMENT '主机地址',
  `oper_location` varchar(255) DEFAULT '' COMMENT '操作地点',
  `oper_param` varchar(2000) DEFAULT '' COMMENT '请求参数',
  `json_result` varchar(2000) DEFAULT '' COMMENT '返回参数',
  `status` int(1) DEFAULT 0 COMMENT '操作状态（0正常 1异常）',
  `error_msg` varchar(2000) DEFAULT '' COMMENT '错误消息',
  `oper_time` datetime DEFAULT NULL COMMENT '操作时间',
  PRIMARY KEY (`oper_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='操作日志记录';
CREATE TABLE `sys_post` (
  `post_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
  `post_code` varchar(64) NOT NULL COMMENT '岗位编码',
  `post_name` varchar(50) NOT NULL COMMENT '岗位名称',
  `post_sort` int(4) NOT NULL COMMENT '显示顺序',
  `status` char(1) NOT NULL COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`post_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='岗位信息表';
CREATE TABLE `sys_role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `role_name` varchar(30) NOT NULL COMMENT '角色名称',
  `role_key` varchar(100) NOT NULL COMMENT '角色权限字符串',
  `role_sort` int(4) NOT NULL COMMENT '显示顺序',
  `data_scope` char(1) DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
  `menu_check_strictly` tinyint(1) DEFAULT 1 COMMENT '菜单树选择项是否关联显示',
  `dept_check_strictly` tinyint(1) DEFAULT 1 COMMENT '部门树选择项是否关联显示',
  `status` char(1) NOT NULL COMMENT '角色状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='角色信息表';
CREATE TABLE `sys_role_dept` (
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `dept_id` bigint(20) NOT NULL COMMENT '部门ID',
  PRIMARY KEY (`role_id`,`dept_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='角色和部门关联表';
CREATE TABLE `sys_role_menu` (
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`role_id`,`menu_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='角色和菜单关联表';
CREATE TABLE `sys_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `user_name` varchar(30) NOT NULL COMMENT '用户账号',
  `nick_name` varchar(30) NOT NULL COMMENT '用户昵称',
  `user_type` varchar(2) DEFAULT '00' COMMENT '用户类型（00系统用户）',
  `email` varchar(50) DEFAULT '' COMMENT '用户邮箱',
  `phonenumber` varchar(11) DEFAULT '' COMMENT '手机号码',
  `sex` char(1) DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
  `avatar` varchar(100) DEFAULT '' COMMENT '头像地址',
  `password` varchar(100) DEFAULT '' COMMENT '密码',
  `vip_level` int(6) DEFAULT 0 COMMENT '用户级别（字典sys_user_vip）',
  `status` char(1) DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `login_ip` varchar(128) DEFAULT '' COMMENT '最后登录IP',
  `login_date` datetime DEFAULT NULL COMMENT '最后登录时间',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='用户信息表';
CREATE TABLE `sys_user_post` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `post_id` bigint(20) NOT NULL COMMENT '岗位ID',
  PRIMARY KEY (`user_id`,`post_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='用户与岗位关联表';
CREATE TABLE `sys_user_role` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`,`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='用户和角色关联表';
BEGIN;
LOCK TABLES `dt_area` WRITE;
DELETE FROM `dt_area`;
INSERT INTO `dt_area` (`uid`,`parent_id`,`ancestors`,`code`,`name`,`vip_level`,`create_by`,`create_time`,`update_by`,`update_time`,`tenant_id`,`remark`) VALUES ('A1676217779814461440', NULL, NULL, 'BASE', '基本数据', 1, 'admin', '2023-07-04 21:13:55', 'admin', '2023-07-04 21:13:55', NULL, NULL),('A292611736020123648', NULL, NULL, 'XXXXXXXXXXX', '测试3主题', 0, 'admin', '2022-03-18 10:54:34', 'admin', '2022-03-18 10:54:34', NULL, NULL);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `dt_model` WRITE;
DELETE FROM `dt_model`;
INSERT INTO `dt_model` (`uid`,`code`,`name`,`data_type`,`area_code`,`slave_sw`,`classify_sw`,`class_prop_sw`,`link_code`,`audit_flag`,`reject_flag`,`state_json`,`menu_json`,`swt_json`,`ext_json`,`version`,`vip_level`,`create_by`,`create_time`,`update_by`,`update_time`,`tenant_id`,`remark`) VALUES ('M1676220774182567936', 'T0000', '模板模型', 'A', 'BASE', '0', '0', '0', NULL, '1', '0', NULL, NULL, '{\"@type\":\"java.util.HashMap\",\"physicTable\":\"1\"}', '{\"@type\":\"java.util.HashMap\"}', 0, 0, 'admin', '2023-07-04 21:25:49', 'admin', '2023-07-04 22:20:23', NULL, NULL),('M1676224654937178112', 'CSCS', '测试测试', 'A', 'BASE', '0', '0', '0', NULL, '1', '0', NULL, NULL, NULL, 'null', 0, 0, 'admin', '2023-07-04 21:41:15', 'admin', '2023-07-04 21:41:15', NULL, NULL),('M296578794743332864', 'CSMX', '测试模型', 'A', 'XXXXXXXXXXX', '0', '0', '0', NULL, '1', '0', NULL, NULL, NULL, NULL, 0, 1, 'admin', '2022-03-29 09:38:14', 'admin', '2022-03-29 09:38:14', NULL, '测试测试测试测试'),('M296582086709936128', 'CSMXB', '测试模型B', 'A', 'XXXXXXXXXXX', '0', '1', '0', '-', '1', '0', NULL, NULL, NULL, NULL, 0, 0, 'admin', '2022-03-29 09:51:19', 'admin', '2022-03-29 09:51:19', NULL, '测试模型B测试模型B测试模型B测试模型B测试模型B');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `dt_prop` WRITE;
DELETE FROM `dt_prop`;
INSERT INTO `dt_prop` (`uid`,`model_code`,`code`,`name`,`data_type`,`view_type`,`src_type`,`quick_sw`,`advance_sw`,`view_sw`,`link_code`,`hide_code`,`col_code`,`col_num`,`swt_json`,`ext_json`,`edit_flag`,`vip_level`,`create_by`,`create_time`,`update_by`,`update_time`,`tenant_id`,`remark`) VALUES ('P299556939935186944', 'CSMXB', 'UID', '序号', 'A', 'A2', '2', '1', '1', '1', NULL, NULL, NULL, 80, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"linkData\":null,\"selectData\":null,\"searchType\":\"0\",\"prefixData\":null,\"maxNum\":null,\"suffixType\":\"0\",\"minNum\":null,\"defaultType\":\"0\",\"defaultExp\":null,\"decLen\":null,\"prefixType\":\"0\",\"linkProp\":null,\"filterExp\":null,\"notNvl\":\"0\",\"minLen\":null,\"suffixData\":null,\"maxLen\":null}', '0', 0, 'admin', '2022-04-06 14:52:19', 'admin', '2023-06-05 09:20:19', NULL, ''),('P302093093016371200', 'CSMXB', 'CODE', '编码', 'A', 'X1', '0', '1', '0', '1', NULL, NULL, NULL, 80, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"linkData\":null,\"selectData\":null,\"searchType\":\"0\",\"prefixData\":null,\"maxNum\":null,\"suffixType\":\"0\",\"minNum\":null,\"defaultType\":\"0\",\"defaultExp\":null,\"decLen\":null,\"prefixType\":\"0\",\"linkProp\":null,\"filterExp\":null,\"notNvl\":\"0\",\"minLen\":null,\"suffixData\":null,\"maxLen\":null}', '0', 0, 'admin', '2022-04-13 14:50:06', 'admin', '2023-06-05 09:21:43', NULL, ''),('P302093206640066560', 'CSMXB', 'VERSION', '版本', 'B', 'X1', '0', '0', '0', '0', NULL, NULL, NULL, 80, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"linkData\":null,\"selectData\":null,\"searchType\":\"0\",\"prefixData\":null,\"maxNum\":null,\"suffixType\":\"0\",\"minNum\":null,\"defaultType\":\"0\",\"defaultExp\":null,\"decLen\":null,\"prefixType\":\"0\",\"linkProp\":null,\"filterExp\":null,\"notNvl\":\"0\",\"minLen\":null,\"suffixData\":null,\"maxLen\":null}', '0', 0, 'admin', '2022-04-13 14:50:33', 'admin', '2022-04-13 14:50:33', NULL, NULL),('P302093497166921728', 'CSMXB', 'CREATE_TIME', '创建时间', 'C', 'X1', '0', '0', '0', '0', NULL, NULL, NULL, 80, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"linkData\":null,\"selectData\":null,\"searchType\":\"0\",\"prefixData\":null,\"maxNum\":null,\"suffixType\":\"0\",\"minNum\":null,\"defaultType\":\"0\",\"defaultExp\":null,\"decLen\":null,\"prefixType\":\"0\",\"linkProp\":null,\"filterExp\":null,\"notNvl\":\"0\",\"minLen\":null,\"suffixData\":null,\"maxLen\":null}', '0', 0, 'admin', '2022-04-13 14:51:42', 'admin', '2022-04-13 14:51:42', NULL, NULL);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `sys_config` WRITE;
DELETE FROM `sys_config`;
INSERT INTO `sys_config` (`config_id`,`config_name`,`config_key`,`config_value`,`config_type`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (1, '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-07 09:10:10', '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow'),(2, '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2022-03-04 13:38:13', '', NULL, '初始化密码 123456'),(3, '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', '2022-03-04 13:38:13', '', NULL, '深色主题theme-dark，浅色主题theme-light'),(4, '账号自助-验证码开关', 'sys.account.captchaOnOff', 'false', 'Y', 'admin', '2022-03-04 13:38:13', 'admin', '2023-07-25 20:19:53', '是否开启验证码功能（true开启，false关闭）'),(5, '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 'admin', '2022-03-04 13:38:13', '', NULL, '是否开启注册用户功能（true开启，false关闭）');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `sys_dept` WRITE;
DELETE FROM `sys_dept`;
INSERT INTO `sys_dept` (`dept_id`,`parent_id`,`ancestors`,`dept_name`,`order_num`,`leader`,`phone`,`email`,`status`,`del_flag`,`create_by`,`create_time`,`update_by`,`update_time`) VALUES (100, 0, '0', '小瓜科技', 0, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-07 10:47:30'),(101, 100, '0,100', '深圳总公司', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-04 13:38:13', '', NULL),(102, 100, '0,100', '长沙分公司', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-04 13:38:13', '', NULL),(103, 101, '0,100,101', '研发部门', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-04 13:38:13', '', NULL),(104, 101, '0,100,101', '市场部门', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-04 13:38:13', '', NULL),(105, 101, '0,100,101', '测试部门', 3, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-04 13:38:13', '', NULL),(106, 101, '0,100,101', '财务部门', 4, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-04 13:38:13', '', NULL),(107, 101, '0,100,101', '运维部门', 5, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-04 13:38:13', '', NULL),(108, 102, '0,100,102', '市场部门', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-04 13:38:13', '', NULL),(109, 102, '0,100,102', '财务部门', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-04 13:38:13', '', NULL);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `sys_dict_data` WRITE;
DELETE FROM `sys_dict_data`;
INSERT INTO `sys_dict_data` (`dict_code`,`dict_sort`,`dict_label`,`dict_value`,`dict_type`,`css_class`,`list_class`,`is_default`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (1, 1, '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '性别男'),(2, 2, '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '性别女'),(3, 3, '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '性别未知'),(4, 1, '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '显示菜单'),(5, 2, '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '隐藏菜单'),(6, 1, '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '正常状态'),(7, 2, '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '停用状态'),(8, 1, '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '正常状态'),(9, 2, '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '停用状态'),(10, 1, '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '默认分组'),(11, 2, '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '系统分组'),(12, 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '系统默认是'),(13, 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '系统默认否'),(14, 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '通知'),(15, 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '公告'),(16, 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '正常状态'),(17, 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '关闭状态'),(18, 1, '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '新增操作'),(19, 2, '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '修改操作'),(20, 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '删除操作'),(21, 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '授权操作'),(22, 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '导出操作'),(23, 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '导入操作'),(24, 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '强退操作'),(25, 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '生成操作'),(26, 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '清空操作'),(27, 1, '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '正常状态'),(28, 2, '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '停用状态'),(100, 1, '普通列表', 'A', 'sys_def_type', NULL, 'info', 'N', '0', 'admin', '2022-03-07 09:14:40', 'admin', '2022-03-17 10:58:17', NULL),(101, 2, '普通层级', 'B', 'sys_def_type', NULL, 'primary', 'N', '0', 'admin', '2022-03-07 09:15:31', 'admin', '2022-03-17 10:58:27', NULL),(104, 3, '唯一扩展', 'C', 'sys_def_type', NULL, 'warning', 'N', '0', 'admin', '2022-03-07 09:23:43', 'admin', '2022-03-17 10:59:27', NULL),(105, 1, 'VIP1', '1', 'sys_user_vip', NULL, 'default', 'N', '0', 'admin', '2022-03-08 10:19:05', 'admin', '2022-03-08 10:19:31', NULL),(106, 2, 'VIP2', '2', 'sys_user_vip', NULL, 'default', 'N', '0', 'admin', '2022-03-08 10:19:26', '', NULL, NULL),(107, 3, 'VIP3', '3', 'sys_user_vip', NULL, 'default', 'N', '0', 'admin', '2022-03-08 10:19:41', '', NULL, NULL),(108, 4, 'VIP4', '4', 'sys_user_vip', NULL, 'default', 'N', '0', 'admin', '2022-03-08 10:20:01', '', NULL, NULL),(109, 5, '绿区用户', '5', 'sys_user_vip', NULL, 'success', 'N', '0', 'admin', '2022-03-08 10:21:13', 'admin', '2022-03-08 10:22:24', NULL),(110, 6, '黄区用户', '6', 'sys_user_vip', NULL, 'warning', 'N', '0', 'admin', '2022-03-08 10:21:37', '', NULL, NULL),(111, 9, '红区用户', '9', 'sys_user_vip', NULL, 'danger', 'N', '0', 'admin', '2022-03-08 10:22:08', '', NULL, NULL),(112, 0, '默认级别', '0', 'sys_user_vip', NULL, 'default', 'N', '0', 'admin', '2022-03-08 10:36:37', 'admin', '2022-03-15 11:06:46', NULL),(113, 4, '多值扩展', 'D', 'sys_def_type', NULL, 'warning', 'N', '0', 'admin', '2022-03-17 10:59:19', '', NULL, NULL),(114, 1, '否', '0', 'sys_def_switch', NULL, 'warning', 'N', '0', 'admin', '2022-03-23 15:08:59', '', NULL, NULL),(115, 2, '是', '1', 'sys_def_switch', NULL, 'primary', 'N', '0', 'admin', '2022-03-23 15:09:14', '', NULL, NULL),(116, 0, '字符', 'A', 'prop_data_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:20:55', 'admin', '2022-03-29 14:22:07', '字符串'),(117, 1, '数值', 'B', 'prop_data_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:21:44', '', NULL, '整数、小数'),(118, 2, '日期', 'C', 'prop_data_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:22:47', '', NULL, '日期、时间'),(119, 5, '文件', 'D', 'prop_data_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:24:33', 'admin', '2022-03-29 14:28:36', '大文本、图片'),(120, 0, '只读', 'X1', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:32:03', 'admin', '2022-03-29 14:49:24', NULL),(121, 12, '下拉选项', 'A2', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:32:36', 'admin', '2022-03-29 14:41:25', NULL),(122, 18, '弹框选择', 'A8', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:32:59', 'admin', '2022-03-30 16:52:20', '配置引用模型'),(123, 34, '日期选择', 'C0', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:33:19', 'admin', '2022-03-29 14:40:02', NULL),(124, 35, '时间选择', 'C1', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:33:57', 'admin', '2022-03-29 14:40:07', NULL),(125, 36, '日期时间', 'C2', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:34:18', 'admin', '2022-03-29 14:40:11', NULL),(126, 11, '键盘输入', 'A1', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:35:24', 'admin', '2022-03-29 14:40:18', NULL),(127, 13, '下拉搜索', 'A3', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:41:45', 'admin', '2022-03-30 16:52:15', '配置引用模型'),(128, 20, '整数输入', 'B0', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:43:46', 'admin', '2022-03-29 14:43:54', NULL),(129, 21, '小数输入', 'B1', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:44:16', '', NULL, NULL),(130, 40, '大文本', 'D0', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:45:54', '', NULL, NULL),(131, 41, '图片', 'D1', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:46:29', '', NULL, NULL),(132, 1, '手动输入', '1', 'prop_source_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:51:11', 'admin', '2022-04-22 14:05:44', NULL),(133, 2, '自定义', '2', 'prop_source_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:52:29', 'admin', '2022-04-22 14:19:12', NULL),(134, 3, '数据字典', '3', 'prop_source_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:52:46', 'admin', '2022-04-22 14:19:19', NULL),(135, 4, '引用模型', '4', 'prop_source_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:53:06', 'admin', '2022-04-22 14:06:31', NULL),(136, 50, '单选按钮', 'E0', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 15:07:15', 'admin', '2022-03-29 15:10:34', NULL),(137, 51, '多选按钮', 'E1', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 15:07:50', 'admin', '2022-03-29 15:10:52', NULL),(138, 0, '无需输入', '0', 'prop_source_type', NULL, 'default', 'N', '0', 'admin', '2022-04-22 14:05:36', 'admin', '2022-04-22 14:07:45', NULL),(140, 5, '编码规则', '5', 'prop_source_type', NULL, 'default', 'N', '0', 'admin', '2022-04-22 14:09:16', 'admin', '2022-04-22 14:14:55', NULL);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `sys_dict_type` WRITE;
DELETE FROM `sys_dict_type`;
INSERT INTO `sys_dict_type` (`dict_id`,`dict_name`,`dict_type`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (1, '用户性别', 'sys_user_sex', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '用户性别列表'),(2, '菜单状态', 'sys_show_hide', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '菜单状态列表'),(3, '系统开关', 'sys_normal_disable', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '系统开关列表'),(4, '任务状态', 'sys_job_status', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '任务状态列表'),(5, '任务分组', 'sys_job_group', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '任务分组列表'),(6, '系统是否', 'sys_yes_no', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '系统是否列表'),(7, '通知类型', 'sys_notice_type', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '通知类型列表'),(8, '通知状态', 'sys_notice_status', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '通知状态列表'),(9, '操作类型', 'sys_oper_type', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '操作类型列表'),(10, '系统状态', 'sys_common_status', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '登录状态列表'),(100, '数据定义类型', 'sys_def_type', '0', 'admin', '2022-03-07 09:13:00', 'admin', '2022-03-29 14:15:38', '模型的类型'),(101, '数据访问级别', 'sys_user_vip', '0', 'admin', '2022-03-08 10:16:44', 'admin', '2022-03-29 14:16:20', '用户的会员级别，数据的访问级别'),(102, '数据定义开关', 'sys_def_switch', '0', 'admin', '2022-03-23 15:07:11', 'admin', '2022-03-29 14:16:08', NULL),(103, '属性数据类型', 'prop_data_type', '0', 'admin', '2022-03-29 14:15:10', '', NULL, NULL),(104, '属性展示类型', 'prop_view_type', '0', 'admin', '2022-03-29 14:17:09', '', NULL, NULL),(105, '属性来源类型', 'prop_source_type', '0', 'admin', '2022-03-29 14:18:38', 'admin', '2022-03-29 14:20:06', NULL);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `sys_logininfor` WRITE;
DELETE FROM `sys_logininfor`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `sys_menu` WRITE;
DELETE FROM `sys_menu`;
INSERT INTO `sys_menu` (`menu_id`,`menu_name`,`parent_id`,`order_num`,`path`,`component`,`query`,`is_frame`,`is_cache`,`menu_type`,`visible`,`status`,`perms`,`icon`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (1, '系统管理', 0, 1, 'system', NULL, '', 1, 0, 'M', '0', '0', '', 'system', 'admin', '2022-03-04 13:38:13', '', NULL, '系统管理目录'),(4, '若依官网*', 0, 4, 'http://ruoyi.vip', NULL, '', 0, 0, 'M', '0', '0', '', 'guide', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-08 15:03:38', '若依官网地址'),(100, '用户管理', 1, 1, 'user', 'system/user/index', '', 1, 0, 'C', '0', '0', 'system:user:list', 'user', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-08 13:38:55', '用户管理菜单'),(101, '角色管理', 1, 2, 'role', 'system/role/index', '', 1, 0, 'C', '0', '0', 'system:role:list', 'peoples', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-08 13:39:01', '角色管理菜单'),(102, '菜单管理', 1, 3, 'menu', 'system/menu/index', '', 1, 0, 'C', '0', '0', 'system:menu:list', 'tree-table', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-08 13:39:07', '菜单管理菜单'),(103, '部门管理', 1, 4, 'dept', 'system/dept/index', '', 1, 0, 'C', '0', '0', 'system:dept:list', 'tree', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-08 13:39:13', '部门管理菜单'),(104, '岗位管理', 1, 5, 'post', 'system/post/index', '', 1, 0, 'C', '0', '0', 'system:post:list', 'post', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-08 13:39:19', '岗位管理菜单'),(105, '字典管理', 1, 6, 'dict', 'system/dict/index', '', 1, 0, 'C', '0', '0', 'system:dict:list', 'dict', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-08 13:39:24', '字典管理菜单'),(106, '参数设置', 1, 7, 'config', 'system/config/index', '', 1, 0, 'C', '0', '0', 'system:config:list', 'edit', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-08 13:39:29', '参数设置菜单'),(107, '通知公告', 1, 8, 'notice', 'system/notice/index', '', 1, 0, 'C', '0', '0', 'system:notice:list', 'message', 'admin', '2022-03-04 13:38:13', '', NULL, '通知公告菜单'),(1001, '用户查询', 100, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:user:query', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1002, '用户新增', 100, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:user:add', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1003, '用户修改', 100, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:user:edit', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1004, '用户删除', 100, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:user:remove', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1005, '用户导出', 100, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:user:export', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1006, '用户导入', 100, 6, '', '', '', 1, 0, 'F', '0', '0', 'system:user:import', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1007, '重置密码', 100, 7, '', '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1008, '角色查询', 101, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:role:query', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1009, '角色新增', 101, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:role:add', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1010, '角色修改', 101, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:role:edit', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1011, '角色删除', 101, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:role:remove', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1012, '角色导出', 101, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:role:export', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1013, '菜单查询', 102, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:query', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1014, '菜单新增', 102, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:add', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1015, '菜单修改', 102, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:edit', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1016, '菜单删除', 102, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:remove', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1017, '部门查询', 103, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:query', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1018, '部门新增', 103, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:add', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1019, '部门修改', 103, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:edit', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1020, '部门删除', 103, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:remove', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1021, '岗位查询', 104, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:post:query', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1022, '岗位新增', 104, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:post:add', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1023, '岗位修改', 104, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:post:edit', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1024, '岗位删除', 104, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:post:remove', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1025, '岗位导出', 104, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:post:export', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1026, '字典查询', 105, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:query', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1027, '字典新增', 105, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:add', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1028, '字典修改', 105, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:edit', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1029, '字典删除', 105, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:remove', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1030, '字典导出', 105, 5, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:export', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1031, '参数查询', 106, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:query', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1032, '参数新增', 106, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:add', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1033, '参数修改', 106, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:edit', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1034, '参数删除', 106, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:remove', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1035, '参数导出', 106, 5, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:export', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1036, '公告查询', 107, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:query', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1037, '公告新增', 107, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:add', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1038, '公告修改', 107, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(1039, '公告删除', 107, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove', '#', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(2000, '数据资产', 0, 2, 'module', NULL, NULL, 1, 0, 'M', '0', '0', '', 'table', 'admin', '2022-03-10 13:53:58', 'admin', '2022-09-09 16:56:06', ''),(2001, '模型定义Old', 2000, 1, 'def', 'assets/def/index', NULL, 1, 0, 'C', '0', '0', 'assets:def:list', 'code', 'admin', '2022-03-10 13:56:14', 'admin', '2022-12-29 10:37:52', ''),(2002, '模型申请', 2000, 2, 'modelx', 'module/model/index', '{\"p\":10}', 1, 0, 'C', '0', '0', 'module:model:index', 'form', 'admin', '2022-09-09 16:27:55', 'admin', '2023-07-25 20:36:53', ''),(2004, '模型预览', 2000, 3, 'modelPre', 'module/model/preview', NULL, 1, 0, 'C', '0', '0', 'module:model:preview', 'build', 'admin', '2023-01-13 11:44:53', 'admin', '2023-01-13 13:47:35', ''),(2007, '模型审核', 2000, 3, 'modelAudit', 'module/model/index', '{\"p\":20}', 1, 0, 'C', '0', '0', 'module:model:index', 'link', 'admin', '2023-07-25 16:27:33', 'admin', '2023-07-25 16:28:50', ''),(2008, '模型发布', 2000, 4, 'modelDeploy', 'module/model/index', '{\"p\":30}', 1, 0, 'C', '0', '0', 'module:model:index', 'guide', 'admin', '2023-07-25 16:30:18', '', NULL, ''),(2009, '模型查询', 2000, 8, 'modelQuery', 'module/model/index', '{\"p\":90}', 1, 0, 'C', '0', '0', 'module:model:index', 'list', 'admin', '2023-07-25 16:32:43', '', NULL, '');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `sys_notice` WRITE;
DELETE FROM `sys_notice`;
INSERT INTO `sys_notice` (`notice_id`,`notice_title`,`notice_type`,`notice_content`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (1, '温馨提醒：2020-07-01 若依新版本发布啦', '2', 0xE696B0E78988E69CACE58685E5AEB9, '0', 'admin', '2022-03-04 13:38:14', 'admin', '2022-03-07 14:17:37', '管理员'),(2, '维护通知：2018-07-01 若依系统凌晨维护', '1', 0xE7BBB4E68AA4E58685E5AEB9, '0', 'admin', '2022-03-04 13:38:14', '', NULL, '管理员');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `sys_oper_log` WRITE;
DELETE FROM `sys_oper_log`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `sys_post` WRITE;
DELETE FROM `sys_post`;
INSERT INTO `sys_post` (`post_id`,`post_code`,`post_name`,`post_sort`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (1, 'ceo', '董事长', 1, '0', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-07 13:53:24', ''),(2, 'se', '项目经理', 2, '0', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(3, 'hr', '人力资源', 3, '0', 'admin', '2022-03-04 13:38:13', '', NULL, ''),(4, 'user', '普通员工', 4, '0', 'admin', '2022-03-04 13:38:13', '', NULL, '');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `sys_role` WRITE;
DELETE FROM `sys_role`;
INSERT INTO `sys_role` (`role_id`,`role_name`,`role_key`,`role_sort`,`data_scope`,`menu_check_strictly`,`dept_check_strictly`,`status`,`del_flag`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (1, '超级管理员', 'admin', 1, '1', 1, 1, '0', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '超级管理员'),(2, '普通角色', 'common', 2, '5', 1, 1, '0', '0', 'admin', '2022-03-04 13:38:13', 'admin', '2022-09-09 16:32:42', '普通角色');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `sys_role_dept` WRITE;
DELETE FROM `sys_role_dept`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `sys_role_menu` WRITE;
DELETE FROM `sys_role_menu`;
INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES (2, 1),(2, 4),(2, 100),(2, 101),(2, 102),(2, 103),(2, 104),(2, 105),(2, 106),(2, 107),(2, 1001),(2, 1002),(2, 1003),(2, 1004),(2, 1005),(2, 1006),(2, 1007),(2, 1008),(2, 1009),(2, 1010),(2, 1011),(2, 1012),(2, 1013),(2, 1014),(2, 1015),(2, 1016),(2, 1017),(2, 1018),(2, 1019),(2, 1020),(2, 1021),(2, 1022),(2, 1023),(2, 1024),(2, 1025),(2, 1026),(2, 1027),(2, 1028),(2, 1029),(2, 1030),(2, 1031),(2, 1032),(2, 1033),(2, 1034),(2, 1035),(2, 1036),(2, 1037),(2, 1038),(2, 1039),(2, 2000),(2, 2002);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `sys_user` WRITE;
DELETE FROM `sys_user`;
INSERT INTO `sys_user` (`user_id`,`dept_id`,`user_name`,`nick_name`,`user_type`,`email`,`phonenumber`,`sex`,`avatar`,`password`,`vip_level`,`status`,`del_flag`,`login_ip`,`login_date`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (1, 103, 'admin', '小瓜', '00', 'ry@163.com', '15888888888', '1', '', '667c756cf9334e328a56e44e906245c8e214c655a160f18fdb84d79c209c49cf', 0, '0', '0', '127.0.0.1', '2023-12-07 15:40:55', 'admin', '2022-03-04 13:38:13', '', '2023-12-07 07:40:55', '管理员'),(2, 105, 'ry', '小瓜', '00', 'ry@qq.com', '15666666666', '1', '', '667c756cf9334e328a56e44e906245c8e214c655a160f18fdb84d79c209c49cf', 1, '0', '0', '127.0.0.1', '2022-03-04 13:38:13', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-23 11:14:22', '测试员');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `sys_user_post` WRITE;
DELETE FROM `sys_user_post`;
INSERT INTO `sys_user_post` (`user_id`,`post_id`) VALUES (1, 1),(2, 2);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `sys_user_role` WRITE;
DELETE FROM `sys_user_role`;
INSERT INTO `sys_user_role` (`user_id`,`role_id`) VALUES (1, 1),(2, 2);
UNLOCK TABLES;
COMMIT;
